022-83718162 / 83715667 chinadse@126.com
Select web_setup,web_upload,web_lockip,web_count,web_today,web_calllist from [wedonet_setup] where id=1
Select id,cid,cdir,sdir,title,preimg,adlist,rootid,pid,depth,idpath,treepath,dirpath,viewcls,readcls,postcls,recls,passcls,repasscls,downcls,tags,readme,postnum,todaynum,isgood,isshow,readurl from [wedonet_class] order by treeid asc
Select * from [wedonet_topic] order by cls asc,id asc
select * from [wedonet_channel] where cha_use=1 order by cha_cls asc,id asc
Select * From [wedonet_group] order by cls asc,id asc
Select * from [wedonet_upclass]
select id,title from wedonet_styleclass where isuse=1
Select cid,pagename,title,str From [wedonet_style] where pagename<>'css' and styleid=40
update wedonet_user set user_atime=GetDate() where id=0
update wedonet_user set isonline=0 where isonline=1 and datediff(n,user_atime,GetDate())>20
select id from wedonet_keyword where title='电视机维修技术视频全套光盘'
update wedonet_keyword set mycount=mycount+1
select top 1 * from [wedonet_video]
select count(*) from [wedonet_video] where isdel=0 and ispass=1 and title like '%电视机维修技术视频全套光盘%'
select top 30 id,classid,preimg,title from [wedonet_video] where isdel=0 and ispass=1 and title like '%电视机维修技术视频全套光盘%'
select top 4 id,classid,preimg,title from [wedonet_video] where isdel=0 and ispass=1 and cid=8 and classid<>-2 and isgood=1 order by istop desc,cls asc,id desc
select top 5 id,classid,title from [wedonet_video] where isdel=0 and ispass=1 and cid=8 and classid<>-2 order by istop desc,cls asc,id desc
select top 1 * from [wedonet_class]
select top 1 * from [wedonet_doc]
select top 8 id,classid,title from [wedonet_doc] where isdel=0 and ispass=1 and cid=4 and classid<>-2 and isgood=1 order by istop desc,cls asc,id desc
select top 1 * from [wedonet_keyword]
select top 10 id,title from [wedonet_keyword] order by mycount desc